Elements and Performance Criteria
- Determine requirements of developing queries
- Write queries to extract required information
- Sort and selectively retrieve values through query writing
- Aggregate records by multiple attributes using an expression
- Sort and filter aggregated records using an expression
- Create queries and retrieve records from multiple tables
- Retrieve records from multiple tables using different expressions and approaches
- Filter records from multiple tables using an expression
- Retrieve records from multiple tables using expressions, set operators and set logic
- Construct and execute sub-queries
- Perform calculations and use expressions in queries
- Create and manipulate tables
- Create and use views and stored procedures
- Create views according to information requirements
- Retrieve and save data using a view and transactions
- Drop a view from a database
- Retrieve, insert and modify data using created and stored procedures according to information requirements
- Create and execute stored procedures using one or more parameters
- Drop a stored procedure from database
- Create and test database triggers and perform specific required data-related functions